Calculating Attribute Values

The calculation of an attribute value is the process of merging multiple values into a single value.

The calculation of attribute values takes place on two levels:

For Recipes:

Recipes are items that have other items as ingredients. For certain attributes, like allergens and ingredient types, the attribute values of the ingredients decide the attribute value of the recipe. In that case the recipe does not have an assigned value; it has a calculated value. The Nuts attribute value for a recipe that contains at least one ingredient with Nuts-Yes, is also Yes.

The system calculates recipes attribute values for attributes that are marked as:

  • Value for Recipe - Calculated from Ingredients

On the POS for Journal Items:

Besides calculating values for recipes, when total attribute values are displayed for the journal lines, the values are merged so that for each attribute only one value is shown.

 

The Calculation Process

The following table shows how the system calculates attribute values based on the value type of the attribute. The same calculation applies to recipe values and to journal values.

Value Type Calculated Value
Text Each unique instance with separator between values, such as Heavy,Light,Big.

Numeric

The sum of the numeric values.
Amount The sum of the amounts.
Date, File Cannot be calculated.
Option Value Each unique instance with separator between values such as Leather,Polyester,Silk.
Table Link Each unique instance with separator between values, such as English,Indonesian,Malaysian.
Weighted Option The option with the highest weight.

 

Manual Calculation for Recipes

You can manually calculate attribute values for recipes in the following ways:

Calculating Values for One Attribute or Attribute Group

  1. Go to Attributes or Attribute Groups (LS Retail or LS Hospitality, Back Office, Product Design, Attributes).
  2. Select the desired attribute or attribute group .
  3. Click Assignment on the action banner. The Attribute Assignments page appears.
  4. Select the attribute values you want to calculate.
  5. Click Calculate Attribute Values for Selection.
  6. Confirm the question.

The system calculates for those attribute values marked with Value Calculated as Yes. When calculation is completed, the system displays the number of values changed.

 

Calculating Values for a Recipe

  1. Go to Recipes (LS Hospitality, Back Office, Product Design, Recipes).
  2. Select the desired recipe.
  3. Click Calculate Attribute Values.

 

The system calculates for those attribute values marked with Value Calculated as Yes. When calculation is completed, the system displays the number of values changed.

 

Calculating Attribute Values for All Recipes - Saving Calculation Time on the POS

You can calculate values for all recipes in the system in one go. This could take time depending on the number of recipes in your system. However, if your recipe and attribute data changes very little or not at all, calculating all recipes saves time on the POS. Recipe values are not calculated on the POS if the system knows that all calculated values are up-to-date.

  1. Go to Attribute Setup (LS Hospitality, Back Office, Product Design,Attributes).
  2. Click on Calculate Values for All Recipes.
  3. Confirm the question.

The system calculates for those attribute values marked with Value Calculated as Yes. When calculation is completed, the system displays the number of values changed. It also fills in the following fields:

  • All Calc. Values Up-to-Date - This field now contains a check mark, indicating that all values are calculated in the system and no need to perform recipe value calculation on the POS. If any changes are then made to attribute values or ingredients are changed, the check mark is removed; values are not up-to-date anymore.
  • Last Date All Values Calcul. - This field contains the date and time when the function was run.
  • Last Modified - This field contains the last modification date and time.

 

Note: When ingredients are excluded from a recipe on the POS, an excluded line is added to the journal. When you select to show attribute values for the recipe after the ingredient exclusion, the system recalculates the recipe attribute values (for attributes marked as Calculated from Ingredients) for non-excluded ingredients only.